package com.gxa.mapper;



import com.gxa.pojo.Contract;
import com.gxa.pojo.Contract_status;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface ContractMapper {
    List<Map> queryContractMap(Integer param1 , Integer param2);

    int insertNewContractList(Contract contract);

    Integer queryCustomeridByName(String customer_name);

    int updateContractStatusList(Contract_status contract_status);

    int deleteContractByNo(String contract_no);

    int updateContractList(Contract contract);

    Map queryContractStatusMap(Integer ID);

    int countContract();

    List<Contract> searchContractByPhone(String contract_search);

    int countContractByPhone(String contract_search);

    int countContractByNo(String contract_search);

    List<Contract> searchContractByNo(String contract_search);

    int countContractByName(String contract_search);

    List<Contract> searchContractByName(String contract_search);

    int updateContractRenewList(@Param("contract_endday") String contract_endday, @Param("contract_summoney")Double contract_summoney,
                                @Param("contract_receivemoney")Double contract_receivemoney,@Param("contract_id")Integer contract_id);

    int updateContractReceive(@Param("contract_receivemoney")Double contract_receivemoney,@Param("contract_id")Integer contract_id);

    int insertContractStatusList(Contract contract);

    List<Map> searchContractByStartday(Integer param1, Integer param2);

    int countContractByStartday();

    List<Map> searchContractByEndday(Integer param1, Integer param2);

    int countContractByEndday();

    List<Map> searchNewContractByWeek(Integer param1, Integer param2);

    int countNewContractByWeek();

    List<Map> searchDueContractByWeek(Integer param1, Integer param2);

    int countDueContractByWeek();

    List<Map> searchDueContractByMonth(Integer param1, Integer param2);

    int countDueContractByMonth();


    List<Map> searchNewContractByMonth(Integer param1, Integer param2);

    int countNewContractByMonth();

    int insertContractPart(String contract_newPart);

    List<Contract> searchContractPart();

}
